/*
 Navicat MySQL Data Transfer

 Source Server         : database
 Source Server Type    : MariaDB
 Source Server Version : 100110
 Source Host           : localhost:3360
 Source Schema         : yiiboot_tmplet

 Target Server Type    : MariaDB
 Target Server Version : 100110
 File Encoding         : 65001

 Date: 01/10/2018 21:17:55
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for admin_log
-- ----------------------------
DROP TABLE IF EXISTS `admin_log`;
CREATE TABLE `admin_log` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `controller_id` varchar(20) DEFAULT NULL COMMENT '控制器ID',
  `action_id` varchar(20) DEFAULT NULL COMMENT '方法ID',
  `url` varchar(200) DEFAULT NULL COMMENT '访问地址',
  `module_name` varchar(50) DEFAULT NULL COMMENT '模块',
  `func_name` varchar(50) DEFAULT NULL COMMENT '功能',
  `right_name` varchar(50) DEFAULT NULL COMMENT '方法',
  `client_ip` varchar(15) DEFAULT NULL COMMENT '客户端IP',
  `create_user` varchar(50) DEFAULT NULL COMMENT '用户',
  `create_date` datetime DEFAULT NULL COMMENT '时间',
  PRIMARY KEY (`id`),
  KEY `index_create_date` (`create_date`),
  KEY `index_create_index` (`create_user`),
  KEY `index_url` (`url`)
) ENGINE=InnoDB AUTO_INCREMENT=224 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of admin_log
-- ----------------------------
BEGIN;
INSERT INTO `admin_log` VALUES (1, 'site', 'error', 'site/error', NULL, NULL, NULL, 'Unknown', 'admin', '2018-08-16 10:05:11');
INSERT INTO `admin_log` VALUES (2, 'admin-role', 'index', 'admin-role/index', '菜单用户权限', '角色管理', '分配权限', 'Unknown', 'admin', '2018-09-30 16:12:14');
INSERT INTO `admin_log` VALUES (3, 'admin-module', 'index', 'admin-module/index', '菜单用户权限', '菜单管理', '一级菜单查看', 'Unknown', 'admin', '2018-09-30 16:12:15');
INSERT INTO `admin_log` VALUES (4, 'admin-module', 'index', 'admin-module/index', '菜单用户权限', '菜单管理', '一级菜单查看', 'Unknown', 'admin', '2018-10-01 08:56:44');
INSERT INTO `admin_log` VALUES (5, 'admin-role', 'index', 'admin-role/index', '菜单用户权限', '角色管理', '分配权限', 'Unknown', 'admin', '2018-10-01 08:56:49');
INSERT INTO `admin_log` VALUES (6, 'admin-module', 'index', 'admin-module/index', '菜单用户权限', '菜单管理', '一级菜单查看', 'Unknown', 'admin', '2018-10-01 08:56:51');
INSERT INTO `admin_log` VALUES (7, 'admin-role', 'index', 'admin-role/index', '菜单用户权限', '角色管理', '分配权限', 'Unknown', 'admin', '2018-10-01 08:56:51');
INSERT INTO `admin_log` VALUES (8, 'admin-user', 'index', 'admin-user/index', '菜单用户权限', '用户管理', '用户操作', 'Unknown', 'admin', '2018-10-01 08:56:53');
INSERT INTO `admin_log` VALUES (9, 'admin-module', 'index', 'admin-module/index', '菜单用户权限', '菜单管理', '一级菜单查看', 'Unknown', 'admin', '2018-10-01 08:56:53');
INSERT INTO `admin_log` VALUES (10, 'admin-role', 'index', 'admin-role/index', '菜单用户权限', '角色管理', '分配权限', 'Unknown', 'admin', '2018-10-01 08:58:02');
INSERT INTO `admin_log` VALUES (11, 'admin-user', 'index', 'admin-user/index', '菜单用户权限', '用户管理', '用户操作', 'Unknown', 'admin', '2018-10-01 08:58:03');
INSERT INTO `admin_log` VALUES (12, 'admin-module', 'index', 'admin-module/index', '菜单用户权限', '菜单管理', '一级菜单查看', 'Unknown', 'admin', '2018-10-01 08:58:15');
INSERT INTO `admin_log` VALUES (13, 'admin-module', 'index', 'admin-module/index', '菜单用户权限', '菜单管理', '一级菜单查看', 'Unknown', 'admin', '2018-10-01 08:58:31');
INSERT INTO `admin_log` VALUES (14, 'admin-role', 'index', 'admin-role/index', '菜单用户权限', '角色管理', '分配权限', 'Unknown', 'admin', '2018-10-01 08:58:32');
INSERT INTO `admin_log` VALUES (15, 'admin-user', 'index', 'admin-user/index', '菜单用户权限', '用户管理', '用户操作', 'Unknown', 'admin', '2018-10-01 08:58:34');
INSERT INTO `admin_log` VALUES (16, 'admin-role', 'index', 'admin-role/index', '菜单用户权限', '角色管理', '分配权限', 'Unknown', 'admin', '2018-10-01 08:58:35');
INSERT INTO `admin_log` VALUES (17, 'admin-module', 'index', 'admin-module/index', '菜单用户权限', '菜单管理', '一级菜单查看', 'Unknown', 'admin', '2018-10-01 08:58:35');
INSERT INTO `admin_log` VALUES (18, 'admin-module', 'index', 'admin-module/index', '菜单用户权限', '菜单管理', '一级菜单查看', 'Unknown', 'admin', '2018-10-01 08:58:36');
INSERT INTO `admin_log` VALUES (19, 'admin-role', 'index', 'admin-role/index', '菜单用户权限', '角色管理', '分配权限', 'Unknown', 'admin', '2018-10-01 11:27:56');
INSERT INTO `admin_log` VALUES (20, 'admin-module', 'index', 'admin-module/index', '菜单用户权限', '菜单管理', '一级菜单查看', 'Unknown', 'admin', '2018-10-01 11:27:57');
INSERT INTO `admin_log` VALUES (21, 'admin-role', 'index', 'admin-role/index', '菜单用户权限', '角色管理', '分配权限', 'Unknown', 'admin', '2018-10-01 11:27:58');
INSERT INTO `admin_log` VALUES (22, 'admin-module', 'index', 'admin-module/index', '菜单用户权限', '菜单管理', '一级菜单查看', 'Unknown', 'admin', '2018-10-01 11:27:59');
INSERT INTO `admin_log` VALUES (23, 'admin-role', 'index', 'admin-role/index', '菜单用户权限', '角色管理', '分配权限', 'Unknown', 'admin', '2018-10-01 11:28:00');
INSERT INTO `admin_log` VALUES (24, 'admin-module', 'index', 'admin-module/index', '菜单用户权限', '菜单管理', '一级菜单查看', 'Unknown', 'admin', '2018-10-01 11:28:02');
INSERT INTO `admin_log` VALUES (25, 'admin-role', 'index', 'admin-role/index', '菜单用户权限', '角色管理', '分配权限', 'Unknown', 'admin', '2018-10-01 11:28:08');
INSERT INTO `admin_log` VALUES (26, 'admin-module', 'index', 'admin-module/index', '菜单用户权限', '菜单管理', '一级菜单查看', 'Unknown', 'admin', '2018-10-01 11:28:09');
INSERT INTO `admin_log` VALUES (27, 'admin-module', 'create', 'admin-module/create', '菜单用户权限', '菜单管理', '一级菜单添加', 'Unknown', 'admin', '2018-10-01 11:28:39');
INSERT INTO `admin_log` VALUES (28, 'admin-module', 'index', 'admin-module/index', '菜单用户权限', '菜单管理', '一级菜单查看', 'Unknown', 'admin', '2018-10-01 11:28:39');
INSERT INTO `admin_log` VALUES (29, 'admin-menu', 'index', 'admin-menu/index', '菜单用户权限', '菜单管理', '二级菜单查看', 'Unknown', 'admin', '2018-10-01 11:28:42');
INSERT INTO `admin_log` VALUES (30, 'admin-module', 'index', 'admin-module/index', '菜单用户权限', '菜单管理', '一级菜单查看', 'Unknown', 'admin', '2018-10-01 11:28:56');
INSERT INTO `admin_log` VALUES (31, 'admin-module', 'view', 'admin-module/view', '菜单用户权限', '菜单管理', '一级菜单查看', 'Unknown', 'admin', '2018-10-01 11:29:03');
INSERT INTO `admin_log` VALUES (32, 'admin-menu', 'index', 'admin-menu/index', '菜单用户权限', '菜单管理', '二级菜单查看', 'Unknown', 'admin', '2018-10-01 11:29:06');
INSERT INTO `admin_log` VALUES (33, 'admin-menu', 'create', 'admin-menu/create', '菜单用户权限', '菜单管理', '二级菜单添加', 'Unknown', 'admin', '2018-10-01 11:29:35');
INSERT INTO `admin_log` VALUES (34, 'admin-menu', 'index', 'admin-menu/index', '菜单用户权限', '菜单管理', '二级菜单查看', 'Unknown', 'admin', '2018-10-01 11:29:35');
INSERT INTO `admin_log` VALUES (35, 'admin-right', 'index', 'admin-right/index', '菜单用户权限', '菜单管理', '路由查看', 'Unknown', 'admin', '2018-10-01 11:29:37');
INSERT INTO `admin_log` VALUES (36, 'admin-right', 'right-action', 'admin-right/right-action', '菜单用户权限', '菜单管理', '路由查看', 'Unknown', 'admin', '2018-10-01 11:29:38');
INSERT INTO `admin_log` VALUES (37, 'admin-right', 'create', 'admin-right/create', '菜单用户权限', '菜单管理', '路由添加', 'Unknown', 'admin', '2018-10-01 11:29:48');
INSERT INTO `admin_log` VALUES (38, 'admin-right', 'index', 'admin-right/index', '菜单用户权限', '菜单管理', '路由查看', 'Unknown', 'admin', '2018-10-01 11:29:48');
INSERT INTO `admin_log` VALUES (39, 'admin-right', 'index', 'admin-right/index', '菜单用户权限', '菜单管理', '路由查看', 'Unknown', 'admin', '2018-10-01 11:29:50');
INSERT INTO `admin_log` VALUES (40, 'admin-module', 'index', 'admin-module/index', '菜单用户权限', '菜单管理', '一级菜单查看', 'Unknown', 'admin', '2018-10-01 11:29:52');
INSERT INTO `admin_log` VALUES (41, 'admin-role', 'index', 'admin-role/index', '菜单用户权限', '角色管理', '分配权限', 'Unknown', 'admin', '2018-10-01 11:29:53');
INSERT INTO `admin_log` VALUES (42, 'admin-role', 'get-all-rights', 'admin-role/get-all-rights', '菜单用户权限', '角色管理', '分配权限', 'Unknown', 'admin', '2018-10-01 11:30:00');
INSERT INTO `admin_log` VALUES (43, 'admin-role', 'save-rights', 'admin-role/save-rights', '菜单用户权限', '角色管理', '分配权限', 'Unknown', 'admin', '2018-10-01 11:30:02');
INSERT INTO `admin_log` VALUES (44, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 11:30:10');
INSERT INTO `admin_log` VALUES (45, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 11:30:14');
INSERT INTO `admin_log` VALUES (46, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 11:30:16');
INSERT INTO `admin_log` VALUES (47, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 11:34:10');
INSERT INTO `admin_log` VALUES (48, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 11:34:17');
INSERT INTO `admin_log` VALUES (49, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 11:39:29');
INSERT INTO `admin_log` VALUES (50, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 11:52:36');
INSERT INTO `admin_log` VALUES (51, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 11:52:49');
INSERT INTO `admin_log` VALUES (52, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 11:53:11');
INSERT INTO `admin_log` VALUES (53, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 11:53:16');
INSERT INTO `admin_log` VALUES (54, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 12:48:24');
INSERT INTO `admin_log` VALUES (55, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 12:48:48');
INSERT INTO `admin_log` VALUES (56, 'images', 'create', 'images/create', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 12:48:58');
INSERT INTO `admin_log` VALUES (57, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 12:48:58');
INSERT INTO `admin_log` VALUES (58, 'images', 'view', 'images/view', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 12:49:05');
INSERT INTO `admin_log` VALUES (59, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 12:50:49');
INSERT INTO `admin_log` VALUES (60, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 12:51:18');
INSERT INTO `admin_log` VALUES (61, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 12:51:24');
INSERT INTO `admin_log` VALUES (62, 'images', 'view', 'images/view', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 12:51:27');
INSERT INTO `admin_log` VALUES (63, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 12:52:43');
INSERT INTO `admin_log` VALUES (64, 'images', 'view', 'images/view', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 12:52:45');
INSERT INTO `admin_log` VALUES (65, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 12:53:20');
INSERT INTO `admin_log` VALUES (66, 'images', 'view', 'images/view', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 12:53:21');
INSERT INTO `admin_log` VALUES (67, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 12:53:33');
INSERT INTO `admin_log` VALUES (68, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 12:54:19');
INSERT INTO `admin_log` VALUES (69, 'images', 'view', 'images/view', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 12:54:20');
INSERT INTO `admin_log` VALUES (70, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 12:54:34');
INSERT INTO `admin_log` VALUES (71, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 12:54:54');
INSERT INTO `admin_log` VALUES (72, 'images', 'view', 'images/view', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 12:54:56');
INSERT INTO `admin_log` VALUES (73, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 12:57:36');
INSERT INTO `admin_log` VALUES (74, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 12:57:38');
INSERT INTO `admin_log` VALUES (75, 'images', 'view', 'images/view', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 12:57:40');
INSERT INTO `admin_log` VALUES (76, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:00:51');
INSERT INTO `admin_log` VALUES (77, 'images', 'view', 'images/view', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:00:56');
INSERT INTO `admin_log` VALUES (78, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:01:08');
INSERT INTO `admin_log` VALUES (79, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:01:18');
INSERT INTO `admin_log` VALUES (80, 'images', 'view', 'images/view', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:01:19');
INSERT INTO `admin_log` VALUES (81, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:01:37');
INSERT INTO `admin_log` VALUES (82, 'images', 'view', 'images/view', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:01:38');
INSERT INTO `admin_log` VALUES (83, 'images', 'view', 'images/view', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:04:45');
INSERT INTO `admin_log` VALUES (84, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:04:48');
INSERT INTO `admin_log` VALUES (85, 'images', 'view', 'images/view', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:04:49');
INSERT INTO `admin_log` VALUES (86, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:05:11');
INSERT INTO `admin_log` VALUES (87, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:12:41');
INSERT INTO `admin_log` VALUES (88, 'images', 'view', 'images/view', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:12:42');
INSERT INTO `admin_log` VALUES (89, 'images', 'view', 'images/view', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:13:28');
INSERT INTO `admin_log` VALUES (90, 'images', 'view', 'images/view', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:13:28');
INSERT INTO `admin_log` VALUES (91, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:17:39');
INSERT INTO `admin_log` VALUES (92, 'images', 'view', 'images/view', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:17:42');
INSERT INTO `admin_log` VALUES (93, 'images', 'update', 'images/update', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:17:46');
INSERT INTO `admin_log` VALUES (94, 'images', 'update', 'images/update', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:17:48');
INSERT INTO `admin_log` VALUES (95, 'images', 'update', 'images/update', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:17:48');
INSERT INTO `admin_log` VALUES (96, 'images', 'update', 'images/update', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:17:48');
INSERT INTO `admin_log` VALUES (97, 'images', 'update', 'images/update', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:17:49');
INSERT INTO `admin_log` VALUES (98, 'images', 'update', 'images/update', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:17:49');
INSERT INTO `admin_log` VALUES (99, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:17:49');
INSERT INTO `admin_log` VALUES (100, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:17:50');
INSERT INTO `admin_log` VALUES (101, 'images', 'view', 'images/view', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:17:52');
INSERT INTO `admin_log` VALUES (102, 'images', 'create', 'images/create', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:17:58');
INSERT INTO `admin_log` VALUES (103, 'images', 'create', 'images/create', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:18:02');
INSERT INTO `admin_log` VALUES (104, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:19:19');
INSERT INTO `admin_log` VALUES (105, 'images', 'view', 'images/view', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:19:20');
INSERT INTO `admin_log` VALUES (106, 'images', 'update', 'images/update', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:19:23');
INSERT INTO `admin_log` VALUES (107, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:19:23');
INSERT INTO `admin_log` VALUES (108, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:19:38');
INSERT INTO `admin_log` VALUES (109, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:20:22');
INSERT INTO `admin_log` VALUES (110, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:20:22');
INSERT INTO `admin_log` VALUES (111, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:20:24');
INSERT INTO `admin_log` VALUES (112, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:20:25');
INSERT INTO `admin_log` VALUES (113, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:20:25');
INSERT INTO `admin_log` VALUES (114, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:20:25');
INSERT INTO `admin_log` VALUES (115, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:20:40');
INSERT INTO `admin_log` VALUES (116, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:20:54');
INSERT INTO `admin_log` VALUES (117, 'images', 'view', 'images/view', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:20:57');
INSERT INTO `admin_log` VALUES (118, 'images', 'update', 'images/update', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:21:00');
INSERT INTO `admin_log` VALUES (119, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:21:00');
INSERT INTO `admin_log` VALUES (120, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:22:04');
INSERT INTO `admin_log` VALUES (121, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:22:06');
INSERT INTO `admin_log` VALUES (122, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:22:07');
INSERT INTO `admin_log` VALUES (123, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:22:07');
INSERT INTO `admin_log` VALUES (124, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:22:08');
INSERT INTO `admin_log` VALUES (125, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:22:09');
INSERT INTO `admin_log` VALUES (126, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:22:32');
INSERT INTO `admin_log` VALUES (127, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:22:34');
INSERT INTO `admin_log` VALUES (128, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:22:34');
INSERT INTO `admin_log` VALUES (129, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:22:34');
INSERT INTO `admin_log` VALUES (130, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:22:35');
INSERT INTO `admin_log` VALUES (131, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:22:35');
INSERT INTO `admin_log` VALUES (132, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:22:35');
INSERT INTO `admin_log` VALUES (133, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:22:35');
INSERT INTO `admin_log` VALUES (134, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:22:36');
INSERT INTO `admin_log` VALUES (135, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:22:36');
INSERT INTO `admin_log` VALUES (136, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:23:45');
INSERT INTO `admin_log` VALUES (137, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:25:47');
INSERT INTO `admin_log` VALUES (138, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:25:49');
INSERT INTO `admin_log` VALUES (139, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:25:50');
INSERT INTO `admin_log` VALUES (140, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:27:21');
INSERT INTO `admin_log` VALUES (141, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:27:22');
INSERT INTO `admin_log` VALUES (142, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:27:31');
INSERT INTO `admin_log` VALUES (143, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:27:33');
INSERT INTO `admin_log` VALUES (144, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:27:33');
INSERT INTO `admin_log` VALUES (145, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:27:34');
INSERT INTO `admin_log` VALUES (146, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:27:35');
INSERT INTO `admin_log` VALUES (147, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:27:35');
INSERT INTO `admin_log` VALUES (148, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:28:50');
INSERT INTO `admin_log` VALUES (149, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:28:51');
INSERT INTO `admin_log` VALUES (150, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:28:51');
INSERT INTO `admin_log` VALUES (151, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:28:51');
INSERT INTO `admin_log` VALUES (152, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:28:52');
INSERT INTO `admin_log` VALUES (153, 'images', 'view', 'images/view', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:28:54');
INSERT INTO `admin_log` VALUES (154, 'images', 'update', 'images/update', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:28:55');
INSERT INTO `admin_log` VALUES (155, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:28:55');
INSERT INTO `admin_log` VALUES (156, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:29:30');
INSERT INTO `admin_log` VALUES (157, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:30:42');
INSERT INTO `admin_log` VALUES (158, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:32:11');
INSERT INTO `admin_log` VALUES (159, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:32:15');
INSERT INTO `admin_log` VALUES (160, 'images', 'view', 'images/view', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:32:35');
INSERT INTO `admin_log` VALUES (161, 'images', 'view', 'images/view', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:34:48');
INSERT INTO `admin_log` VALUES (162, 'images', 'update', 'images/update', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:34:51');
INSERT INTO `admin_log` VALUES (163, 'images', 'update', 'images/update', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:35:15');
INSERT INTO `admin_log` VALUES (164, 'images', 'update', 'images/update', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:35:27');
INSERT INTO `admin_log` VALUES (165, 'images', 'update', 'images/update', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:35:52');
INSERT INTO `admin_log` VALUES (166, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:35:58');
INSERT INTO `admin_log` VALUES (167, 'images', 'view', 'images/view', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:35:59');
INSERT INTO `admin_log` VALUES (168, 'images', 'update', 'images/update', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:36:01');
INSERT INTO `admin_log` VALUES (169, 'images', 'update', 'images/update', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:36:07');
INSERT INTO `admin_log` VALUES (170, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:36:10');
INSERT INTO `admin_log` VALUES (171, 'images', 'view', 'images/view', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:36:29');
INSERT INTO `admin_log` VALUES (172, 'images', 'update', 'images/update', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:36:36');
INSERT INTO `admin_log` VALUES (173, 'images', 'update', 'images/update', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:36:40');
INSERT INTO `admin_log` VALUES (174, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:52:20');
INSERT INTO `admin_log` VALUES (175, 'images', 'view', 'images/view', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:52:23');
INSERT INTO `admin_log` VALUES (176, 'images', 'update', 'images/update', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:52:32');
INSERT INTO `admin_log` VALUES (177, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:52:32');
INSERT INTO `admin_log` VALUES (178, 'images', 'view', 'images/view', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:54:33');
INSERT INTO `admin_log` VALUES (179, 'images', 'update', 'images/update', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:54:42');
INSERT INTO `admin_log` VALUES (180, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:54:42');
INSERT INTO `admin_log` VALUES (181, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 13:54:45');
INSERT INTO `admin_log` VALUES (182, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 14:00:17');
INSERT INTO `admin_log` VALUES (183, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 14:00:58');
INSERT INTO `admin_log` VALUES (184, 'images', 'view', 'images/view', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 14:06:49');
INSERT INTO `admin_log` VALUES (185, 'images', 'view', 'images/view', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 14:06:53');
INSERT INTO `admin_log` VALUES (186, 'images', 'view', 'images/view', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 14:06:56');
INSERT INTO `admin_log` VALUES (187, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 14:09:15');
INSERT INTO `admin_log` VALUES (188, 'images', 'view', 'images/view', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 14:09:17');
INSERT INTO `admin_log` VALUES (189, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 14:10:00');
INSERT INTO `admin_log` VALUES (190, 'images', 'view', 'images/view', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 14:10:02');
INSERT INTO `admin_log` VALUES (191, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 14:10:06');
INSERT INTO `admin_log` VALUES (192, 'images', 'view', 'images/view', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 14:10:10');
INSERT INTO `admin_log` VALUES (193, 'images', 'view', 'images/view', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 14:11:19');
INSERT INTO `admin_log` VALUES (194, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 14:11:50');
INSERT INTO `admin_log` VALUES (195, 'images', 'view', 'images/view', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 14:11:52');
INSERT INTO `admin_log` VALUES (196, 'images', 'view', 'images/view', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 14:11:53');
INSERT INTO `admin_log` VALUES (197, 'images', 'view', 'images/view', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 14:11:54');
INSERT INTO `admin_log` VALUES (198, 'images', 'view', 'images/view', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 14:11:55');
INSERT INTO `admin_log` VALUES (199, 'images', 'view', 'images/view', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 14:11:56');
INSERT INTO `admin_log` VALUES (200, 'images', 'view', 'images/view', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 14:11:56');
INSERT INTO `admin_log` VALUES (201, 'images', 'view', 'images/view', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 14:11:56');
INSERT INTO `admin_log` VALUES (202, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 14:12:17');
INSERT INTO `admin_log` VALUES (203, 'images', 'view', 'images/view', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 14:12:21');
INSERT INTO `admin_log` VALUES (204, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 14:14:43');
INSERT INTO `admin_log` VALUES (205, 'images', 'view', 'images/view', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 14:14:44');
INSERT INTO `admin_log` VALUES (206, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 14:14:47');
INSERT INTO `admin_log` VALUES (207, 'images', 'view', 'images/view', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 14:14:48');
INSERT INTO `admin_log` VALUES (208, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 14:15:32');
INSERT INTO `admin_log` VALUES (209, 'images', 'view', 'images/view', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 14:15:35');
INSERT INTO `admin_log` VALUES (210, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 14:17:10');
INSERT INTO `admin_log` VALUES (211, 'images', 'view', 'images/view', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 14:17:12');
INSERT INTO `admin_log` VALUES (212, 'images', 'view', 'images/view', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 14:17:16');
INSERT INTO `admin_log` VALUES (213, 'images', 'view', 'images/view', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 14:17:18');
INSERT INTO `admin_log` VALUES (214, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 14:18:36');
INSERT INTO `admin_log` VALUES (215, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 14:18:43');
INSERT INTO `admin_log` VALUES (216, 'images', 'view', 'images/view', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 14:18:44');
INSERT INTO `admin_log` VALUES (217, 'images', 'view', 'images/view', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 14:18:49');
INSERT INTO `admin_log` VALUES (218, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 14:19:05');
INSERT INTO `admin_log` VALUES (219, 'images', 'view', 'images/view', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 14:19:08');
INSERT INTO `admin_log` VALUES (220, 'images', 'update', 'images/update', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 14:19:55');
INSERT INTO `admin_log` VALUES (221, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 14:20:05');
INSERT INTO `admin_log` VALUES (222, 'images', 'index', 'images/index', '图片上传', '图片管理', '上传', 'Unknown', 'admin', '2018-10-01 14:20:09');
INSERT INTO `admin_log` VALUES (223, 'admin-module', 'index', 'admin-module/index', '菜单用户权限', '菜单管理', '一级菜单查看', 'Unknown', 'admin', '2018-10-01 15:12:00');
COMMIT;

-- ----------------------------
-- Table structure for admin_menu
-- ----------------------------
DROP TABLE IF EXISTS `admin_menu`;
CREATE TABLE `admin_menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `code` varchar(50) NOT NULL COMMENT 'code',
  `menu_name` varchar(200) NOT NULL COMMENT '名称',
  `module_id` int(11) NOT NULL COMMENT '模块id',
  `display_label` varchar(200) DEFAULT NULL COMMENT '显示名',
  `des` varchar(400) DEFAULT NULL COMMENT '描述',
  `display_order` int(5) DEFAULT NULL COMMENT '显示顺序',
  `entry_right_name` varchar(50) DEFAULT NULL COMMENT '入口地址名称',
  `entry_url` varchar(200) NOT NULL COMMENT '入口地址',
  `action` varchar(50) NOT NULL COMMENT '操作ID',
  `controller` varchar(100) NOT NULL COMMENT '控制器ID',
  `has_lef` varchar(1) NOT NULL DEFAULT 'n' COMMENT '是否有子',
  `create_user` varchar(50) DEFAULT NULL COMMENT '创建人',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `update_user` varchar(50) DEFAULT NULL COMMENT '修改人',
  `update_date` datetime DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `index_code` (`code`),
  KEY `fk_module_id` (`module_id`),
  CONSTRAINT `fk_module_id` FOREIGN KEY (`module_id`) REFERENCES `admin_module` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of admin_menu
-- ----------------------------
BEGIN;
INSERT INTO `admin_menu` VALUES (1, 'menu_manger', '菜单管理', 1, '菜单管理', '菜单管理', 1, '菜单管理', 'admin-module/index', 'index', 'backend\\controllers\\AdminMenuController', 'n', 'admin', '2016-08-11 16:44:11', 'admin', '2016-08-11 16:44:11');
INSERT INTO `admin_menu` VALUES (2, 'menu_role', '角色管理', 1, '角色管理', '角色管理', 2, '角色管理', 'admin-role/index', 'index', 'backend\\controllers\\AdminRoleController', 'n', 'admin', '2016-08-11 16:51:56', 'admin', '2016-08-11 16:51:56');
INSERT INTO `admin_menu` VALUES (3, 'menu_user', '用户管理', 1, '用户管理', '用户管理', 3, '用户管理', 'admin-user/index', 'index', 'backend\\controllers\\AdminUserController', 'n', 'admin', '2016-08-11 16:58:43', 'admin', '2016-08-11 16:58:43');
INSERT INTO `admin_menu` VALUES (4, 'coazaorizhi', '操作日志', 2, '操作日志', '操作日志', 1, '', 'admin-log/index', 'index', 'backend\\controllers\\AdminLogController', 'n', 'test', '2016-08-14 06:54:17', 'test', '2016-08-14 06:54:17');
INSERT INTO `admin_menu` VALUES (5, 'imagesupload', '图片管理', 3, '图片管理', '', NULL, '图片管理', 'images/index', 'index', 'backend\\controllers\\ImagesController', 'n', 'admin', '2018-10-01 11:29:35', 'admin', '2018-10-01 11:29:35');
COMMIT;

-- ----------------------------
-- Table structure for admin_message
-- ----------------------------
DROP TABLE IF EXISTS `admin_message`;
CREATE TABLE `admin_message` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `msg` varchar(1000) DEFAULT NULL COMMENT '留言内容',
  `expiry_days` int(5) unsigned DEFAULT NULL COMMENT '有效天数',
  `create_user` varchar(50) DEFAULT NULL,
  `create_date` datetime DEFAULT NULL,
  `update_user` varchar(50) DEFAULT NULL,
  `update_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of admin_message
-- ----------------------------
BEGIN;
INSERT INTO `admin_message` VALUES (1, '测试文本', 1, 'admin', '2014-11-21 18:47:20', 'admin', '2014-11-21 18:47:27');
COMMIT;

-- ----------------------------
-- Table structure for admin_module
-- ----------------------------
DROP TABLE IF EXISTS `admin_module`;
CREATE TABLE `admin_module` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `code` varchar(50) NOT NULL COMMENT 'code',
  `display_label` varchar(200) NOT NULL COMMENT '显示名称',
  `has_lef` varchar(1) NOT NULL DEFAULT 'n' COMMENT '是否有子',
  `des` varchar(400) DEFAULT NULL COMMENT '描述',
  `entry_url` varchar(100) DEFAULT NULL COMMENT '入口地址',
  `display_order` int(5) DEFAULT NULL COMMENT '顺序',
  `create_user` varchar(50) DEFAULT NULL COMMENT '创建人',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `update_user` varchar(50) DEFAULT NULL COMMENT '修改人',
  `update_date` datetime DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of admin_module
-- ----------------------------
BEGIN;
INSERT INTO `admin_module` VALUES (1, 'menu_manage', '菜单用户权限', 'n', '菜单管理', '', 1, 'admin', '2016-08-11 15:26:21', 'admin', '2016-08-11 16:31:08');
INSERT INTO `admin_module` VALUES (2, 'rizhimaanage', '日志管理', 'n', '日志管理', '', 2, 'test', '2016-08-14 06:53:13', 'test', '2016-08-14 06:53:13');
INSERT INTO `admin_module` VALUES (3, 'images', '图片上传', 'n', '', NULL, NULL, 'admin', '2018-10-01 11:28:39', 'admin', '2018-10-01 11:28:39');
COMMIT;

-- ----------------------------
-- Table structure for admin_right
-- ----------------------------
DROP TABLE IF EXISTS `admin_right`;
CREATE TABLE `admin_right` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `menu_id` int(11) NOT NULL COMMENT '功能主键',
  `right_name` varchar(200) NOT NULL COMMENT '名称',
  `display_label` varchar(200) DEFAULT NULL COMMENT '显示名',
  `des` varchar(200) DEFAULT NULL COMMENT '描述',
  `display_order` int(5) DEFAULT NULL COMMENT '显示顺序',
  `has_lef` varchar(1) NOT NULL DEFAULT 'n' COMMENT '是否有子',
  `create_user` varchar(50) DEFAULT NULL COMMENT '创建人',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `update_user` varchar(50) DEFAULT NULL COMMENT '修改人',
  `update_date` datetime DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`),
  KEY `FK_admin_right` (`menu_id`),
  KEY `index_menu_id` (`menu_id`),
  CONSTRAINT `FK_admin_right` FOREIGN KEY (`menu_id`) REFERENCES `admin_menu` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of admin_right
-- ----------------------------
BEGIN;
INSERT INTO `admin_right` VALUES (4, 2, '角色操作', '角色操作', '角色操作', 1, 'n', 'admin', '2016-08-13 17:04:40', 'admin', '2016-08-13 17:04:40');
INSERT INTO `admin_right` VALUES (5, 2, '分配用户', '分配用户', '分配用户', 2, 'n', 'admin', '2016-08-13 17:05:04', 'test', '2016-08-14 08:22:13');
INSERT INTO `admin_right` VALUES (6, 2, '分配权限', '分配权限', '分配权限', 3, 'n', 'admin', '2016-08-13 17:05:24', 'admin', '2016-08-13 17:05:24');
INSERT INTO `admin_right` VALUES (7, 3, '用户操作', '用户操作', '用户操作', 1, 'n', 'admin', '2016-08-13 17:05:57', 'admin', '2016-08-13 17:05:57');
INSERT INTO `admin_right` VALUES (8, 4, '操作', '操作', '操作', 1, 'n', 'test', '2016-08-14 06:54:38', 'test', '2016-08-14 06:54:38');
INSERT INTO `admin_right` VALUES (13, 1, '一级菜单查看', '一级菜单查看', '一级菜单查看', 1, 'n', 'test', '2016-08-16 15:52:45', 'test', '2016-08-16 15:52:45');
INSERT INTO `admin_right` VALUES (14, 1, '一级菜单添加', '一级菜单添加', '一级菜单添加', 2, 'n', 'test', '2016-08-16 15:53:10', 'test', '2016-08-16 15:58:30');
INSERT INTO `admin_right` VALUES (15, 1, '一级菜单删除', '一级菜单删除', '一级菜单删除', 3, 'n', 'test', '2016-08-16 15:53:44', 'test', '2016-08-16 15:53:44');
INSERT INTO `admin_right` VALUES (16, 1, '二级菜单查看', '二级菜单查看', '二级菜单查看', 4, 'n', 'test', '2016-08-16 15:55:02', 'test', '2016-08-16 15:55:02');
INSERT INTO `admin_right` VALUES (17, 1, '二级菜单添加', '二级菜单修改', '二级菜单添加', 5, 'n', 'test', '2016-08-16 15:55:21', 'test', '2016-08-16 15:58:50');
INSERT INTO `admin_right` VALUES (18, 1, '二级菜单删除', '二级菜单删除', '二级菜单删除', 6, 'n', 'test', '2016-08-16 15:55:58', 'test', '2016-08-16 15:55:58');
INSERT INTO `admin_right` VALUES (19, 1, '路由查看', '路由查看', '路由查看', 7, 'n', 'test', '2016-08-16 15:56:32', 'test', '2016-08-16 15:57:14');
INSERT INTO `admin_right` VALUES (20, 1, '路由添加', '路由添加', '路由添加', 8, 'n', 'test', '2016-08-16 15:57:46', 'test', '2016-08-16 15:57:46');
INSERT INTO `admin_right` VALUES (21, 1, '路由删除', '路由删除', '路由删除', 9, 'n', 'test', '2016-08-16 15:58:05', 'test', '2016-08-16 15:58:05');
INSERT INTO `admin_right` VALUES (22, 5, '上传', '上传', '', NULL, 'n', 'admin', '2018-10-01 11:29:48', 'admin', '2018-10-01 11:29:48');
COMMIT;

-- ----------------------------
-- Table structure for admin_right_url
-- ----------------------------
DROP TABLE IF EXISTS `admin_right_url`;
CREATE TABLE `admin_right_url` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `right_id` int(11) NOT NULL COMMENT 'right主键',
  `url` varchar(200) DEFAULT NULL COMMENT 'url',
  `para_name` varchar(40) DEFAULT NULL COMMENT '参数名',
  `para_value` varchar(40) DEFAULT NULL COMMENT '参数值',
  `create_user` varchar(50) DEFAULT NULL COMMENT '创建人',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `update_user` varchar(50) DEFAULT NULL COMMENT '修改人',
  `update_date` datetime DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`),
  KEY `FK_admin_right_url` (`right_id`),
  KEY `index_right_id` (`right_id`),
  CONSTRAINT `FK_admin_right_url` FOREIGN KEY (`right_id`) REFERENCES `admin_right` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=140 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of admin_right_url
-- ----------------------------
BEGIN;
INSERT INTO `admin_right_url` VALUES (16, 4, 'admin-role/index', 'admin-role', 'index', 'admin', '2016-08-13 17:04:40', 'admin', '2016-08-13 17:04:40');
INSERT INTO `admin_right_url` VALUES (17, 4, 'admin-role/view', 'admin-role', 'view', 'admin', '2016-08-13 17:04:40', 'admin', '2016-08-13 17:04:40');
INSERT INTO `admin_right_url` VALUES (18, 4, 'admin-role/create', 'admin-role', 'create', 'admin', '2016-08-13 17:04:40', 'admin', '2016-08-13 17:04:40');
INSERT INTO `admin_right_url` VALUES (19, 4, 'admin-role/update', 'admin-role', 'update', 'admin', '2016-08-13 17:04:40', 'admin', '2016-08-13 17:04:40');
INSERT INTO `admin_right_url` VALUES (20, 4, 'admin-role/delete', 'admin-role', 'delete', 'admin', '2016-08-13 17:04:40', 'admin', '2016-08-13 17:04:40');
INSERT INTO `admin_right_url` VALUES (21, 4, 'admin-role/get-all-rights', 'admin-role', 'get-all-rights', 'admin', '2016-08-13 17:04:40', 'admin', '2016-08-13 17:04:40');
INSERT INTO `admin_right_url` VALUES (22, 4, 'admin-role/save-rights', 'admin-role', 'save-rights', 'admin', '2016-08-13 17:04:40', 'admin', '2016-08-13 17:04:40');
INSERT INTO `admin_right_url` VALUES (30, 6, 'admin-role/index', 'admin-role', 'index', 'admin', '2016-08-13 17:05:24', 'admin', '2016-08-13 17:05:24');
INSERT INTO `admin_right_url` VALUES (31, 6, 'admin-role/view', 'admin-role', 'view', 'admin', '2016-08-13 17:05:24', 'admin', '2016-08-13 17:05:24');
INSERT INTO `admin_right_url` VALUES (32, 6, 'admin-role/create', 'admin-role', 'create', 'admin', '2016-08-13 17:05:24', 'admin', '2016-08-13 17:05:24');
INSERT INTO `admin_right_url` VALUES (33, 6, 'admin-role/update', 'admin-role', 'update', 'admin', '2016-08-13 17:05:24', 'admin', '2016-08-13 17:05:24');
INSERT INTO `admin_right_url` VALUES (34, 6, 'admin-role/delete', 'admin-role', 'delete', 'admin', '2016-08-13 17:05:24', 'admin', '2016-08-13 17:05:24');
INSERT INTO `admin_right_url` VALUES (35, 6, 'admin-role/get-all-rights', 'admin-role', 'get-all-rights', 'admin', '2016-08-13 17:05:24', 'admin', '2016-08-13 17:05:24');
INSERT INTO `admin_right_url` VALUES (36, 6, 'admin-role/save-rights', 'admin-role', 'save-rights', 'admin', '2016-08-13 17:05:24', 'admin', '2016-08-13 17:05:24');
INSERT INTO `admin_right_url` VALUES (37, 7, 'admin-user/index', 'admin-user', 'index', 'admin', '2016-08-13 17:05:57', 'admin', '2016-08-13 17:05:57');
INSERT INTO `admin_right_url` VALUES (38, 7, 'admin-user/view', 'admin-user', 'view', 'admin', '2016-08-13 17:05:57', 'admin', '2016-08-13 17:05:57');
INSERT INTO `admin_right_url` VALUES (39, 7, 'admin-user/create', 'admin-user', 'create', 'admin', '2016-08-13 17:05:57', 'admin', '2016-08-13 17:05:57');
INSERT INTO `admin_right_url` VALUES (40, 7, 'admin-user/update', 'admin-user', 'update', 'admin', '2016-08-13 17:05:57', 'admin', '2016-08-13 17:05:57');
INSERT INTO `admin_right_url` VALUES (41, 7, 'admin-user/delete', 'admin-user', 'delete', 'admin', '2016-08-13 17:05:57', 'admin', '2016-08-13 17:05:57');
INSERT INTO `admin_right_url` VALUES (42, 8, 'admin-log/index', 'admin-log', 'index', 'test', '2016-08-14 06:54:38', 'test', '2016-08-14 06:54:38');
INSERT INTO `admin_right_url` VALUES (43, 8, 'admin-log/view', 'admin-log', 'view', 'test', '2016-08-14 06:54:38', 'test', '2016-08-14 06:54:38');
INSERT INTO `admin_right_url` VALUES (44, 8, 'admin-log/create', 'admin-log', 'create', 'test', '2016-08-14 06:54:38', 'test', '2016-08-14 06:54:38');
INSERT INTO `admin_right_url` VALUES (45, 8, 'admin-log/update', 'admin-log', 'update', 'test', '2016-08-14 06:54:38', 'test', '2016-08-14 06:54:38');
INSERT INTO `admin_right_url` VALUES (46, 8, 'admin-log/delete', 'admin-log', 'delete', 'test', '2016-08-14 06:54:38', 'test', '2016-08-14 06:54:38');
INSERT INTO `admin_right_url` VALUES (81, 5, 'admin-user-role/index', 'admin-user-role', 'index', 'test', '2016-08-14 08:22:13', 'test', '2016-08-14 08:22:13');
INSERT INTO `admin_right_url` VALUES (82, 5, 'admin-user-role/view', 'admin-user-role', 'view', 'test', '2016-08-14 08:22:13', 'test', '2016-08-14 08:22:13');
INSERT INTO `admin_right_url` VALUES (83, 5, 'admin-user-role/create', 'admin-user-role', 'create', 'test', '2016-08-14 08:22:13', 'test', '2016-08-14 08:22:13');
INSERT INTO `admin_right_url` VALUES (84, 5, 'admin-user-role/update', 'admin-user-role', 'update', 'test', '2016-08-14 08:22:13', 'test', '2016-08-14 08:22:13');
INSERT INTO `admin_right_url` VALUES (85, 5, 'admin-user-role/delete', 'admin-user-role', 'delete', 'test', '2016-08-14 08:22:13', 'test', '2016-08-14 08:22:13');
INSERT INTO `admin_right_url` VALUES (112, 13, 'admin-module/index', 'admin-module', 'index', 'test', '2016-08-16 15:52:45', 'test', '2016-08-16 15:52:45');
INSERT INTO `admin_right_url` VALUES (113, 13, 'admin-module/view', 'admin-module', 'view', 'test', '2016-08-16 15:52:45', 'test', '2016-08-16 15:52:45');
INSERT INTO `admin_right_url` VALUES (115, 15, 'admin-module/delete', 'admin-module', 'delete', 'test', '2016-08-16 15:53:44', 'test', '2016-08-16 15:53:44');
INSERT INTO `admin_right_url` VALUES (118, 16, 'admin-menu/index', 'admin-menu', 'index', 'test', '2016-08-16 15:55:02', 'test', '2016-08-16 15:55:02');
INSERT INTO `admin_right_url` VALUES (119, 16, 'admin-menu/view', 'admin-menu', 'view', 'test', '2016-08-16 15:55:02', 'test', '2016-08-16 15:55:02');
INSERT INTO `admin_right_url` VALUES (122, 18, 'admin-menu/delete', 'admin-menu', 'delete', 'test', '2016-08-16 15:55:58', 'test', '2016-08-16 15:55:58');
INSERT INTO `admin_right_url` VALUES (125, 19, 'admin-right/index', 'admin-right', 'index', 'test', '2016-08-16 15:57:14', 'test', '2016-08-16 15:57:14');
INSERT INTO `admin_right_url` VALUES (126, 19, 'admin-right/view', 'admin-right', 'view', 'test', '2016-08-16 15:57:14', 'test', '2016-08-16 15:57:14');
INSERT INTO `admin_right_url` VALUES (127, 19, 'admin-right/right-action', 'admin-right', 'right-action', 'test', '2016-08-16 15:57:14', 'test', '2016-08-16 15:57:14');
INSERT INTO `admin_right_url` VALUES (128, 20, 'admin-right/create', 'admin-right', 'create', 'test', '2016-08-16 15:57:46', 'test', '2016-08-16 15:57:46');
INSERT INTO `admin_right_url` VALUES (129, 20, 'admin-right/update', 'admin-right', 'update', 'test', '2016-08-16 15:57:46', 'test', '2016-08-16 15:57:46');
INSERT INTO `admin_right_url` VALUES (130, 21, 'admin-right/delete', 'admin-right', 'delete', 'test', '2016-08-16 15:58:05', 'test', '2016-08-16 15:58:05');
INSERT INTO `admin_right_url` VALUES (131, 14, 'admin-module/create', 'admin-module', 'create', 'test', '2016-08-16 15:58:30', 'test', '2016-08-16 15:58:30');
INSERT INTO `admin_right_url` VALUES (132, 14, 'admin-module/update', 'admin-module', 'update', 'test', '2016-08-16 15:58:30', 'test', '2016-08-16 15:58:30');
INSERT INTO `admin_right_url` VALUES (133, 17, 'admin-menu/create', 'admin-menu', 'create', 'test', '2016-08-16 15:58:51', 'test', '2016-08-16 15:58:51');
INSERT INTO `admin_right_url` VALUES (134, 17, 'admin-menu/update', 'admin-menu', 'update', 'test', '2016-08-16 15:58:51', 'test', '2016-08-16 15:58:51');
INSERT INTO `admin_right_url` VALUES (135, 22, 'images/index', 'images', 'index', 'admin', '2018-10-01 11:29:48', 'admin', '2018-10-01 11:29:48');
INSERT INTO `admin_right_url` VALUES (136, 22, 'images/view', 'images', 'view', 'admin', '2018-10-01 11:29:48', 'admin', '2018-10-01 11:29:48');
INSERT INTO `admin_right_url` VALUES (137, 22, 'images/create', 'images', 'create', 'admin', '2018-10-01 11:29:48', 'admin', '2018-10-01 11:29:48');
INSERT INTO `admin_right_url` VALUES (138, 22, 'images/update', 'images', 'update', 'admin', '2018-10-01 11:29:48', 'admin', '2018-10-01 11:29:48');
INSERT INTO `admin_right_url` VALUES (139, 22, 'images/delete', 'images', 'delete', 'admin', '2018-10-01 11:29:48', 'admin', '2018-10-01 11:29:48');
COMMIT;

-- ----------------------------
-- Table structure for admin_role
-- ----------------------------
DROP TABLE IF EXISTS `admin_role`;
CREATE TABLE `admin_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `code` varchar(50) NOT NULL COMMENT '角色编号',
  `name` varchar(50) NOT NULL COMMENT '角色名称',
  `des` varchar(400) DEFAULT NULL COMMENT '角色描述',
  `create_user` varchar(50) DEFAULT NULL COMMENT '创建人',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `update_user` varchar(50) DEFAULT NULL COMMENT '更新人',
  `update_date` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `index_code` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of admin_role
-- ----------------------------
BEGIN;
INSERT INTO `admin_role` VALUES (1, 'superadmin', '超级管理员', '拥有所有权限', 'test', '2016-08-12 15:33:01', 'test', '2016-08-12 15:33:01');
INSERT INTO `admin_role` VALUES (2, 'testuser', '测试人员', '测试人员', 'test', '2016-08-12 15:33:45', 'test', '2016-08-12 15:33:45');
COMMIT;

-- ----------------------------
-- Table structure for admin_role_right
-- ----------------------------
DROP TABLE IF EXISTS `admin_role_right`;
CREATE TABLE `admin_role_right` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `role_id` int(11) NOT NULL COMMENT '角色主键',
  `right_id` int(11) NOT NULL COMMENT '权限主键',
  `full_path` varchar(250) DEFAULT NULL COMMENT '全路径',
  `create_user` varchar(50) DEFAULT NULL COMMENT '创建人',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `update_user` varchar(50) DEFAULT NULL COMMENT '修改人',
  `update_date` datetime DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`),
  KEY `index_role_id` (`role_id`),
  KEY `index_right_id` (`right_id`),
  CONSTRAINT `admin_role_right_ibfk_1` FOREIGN KEY (`right_id`) REFERENCES `admin_right` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=141 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of admin_role_right
-- ----------------------------
BEGIN;
INSERT INTO `admin_role_right` VALUES (112, 2, 13, NULL, 'test', '2016-08-16 16:02:57', 'test', '2016-08-16 16:02:57');
INSERT INTO `admin_role_right` VALUES (113, 2, 14, NULL, 'test', '2016-08-16 16:02:57', 'test', '2016-08-16 16:02:57');
INSERT INTO `admin_role_right` VALUES (114, 2, 15, NULL, 'test', '2016-08-16 16:02:57', 'test', '2016-08-16 16:02:57');
INSERT INTO `admin_role_right` VALUES (115, 2, 16, NULL, 'test', '2016-08-16 16:02:57', 'test', '2016-08-16 16:02:57');
INSERT INTO `admin_role_right` VALUES (116, 2, 17, NULL, 'test', '2016-08-16 16:02:57', 'test', '2016-08-16 16:02:57');
INSERT INTO `admin_role_right` VALUES (117, 2, 18, NULL, 'test', '2016-08-16 16:02:57', 'test', '2016-08-16 16:02:57');
INSERT INTO `admin_role_right` VALUES (118, 2, 19, NULL, 'test', '2016-08-16 16:02:57', 'test', '2016-08-16 16:02:57');
INSERT INTO `admin_role_right` VALUES (119, 2, 20, NULL, 'test', '2016-08-16 16:02:57', 'test', '2016-08-16 16:02:57');
INSERT INTO `admin_role_right` VALUES (120, 2, 21, NULL, 'test', '2016-08-16 16:02:57', 'test', '2016-08-16 16:02:57');
INSERT INTO `admin_role_right` VALUES (121, 2, 4, NULL, 'test', '2016-08-16 16:02:57', 'test', '2016-08-16 16:02:57');
INSERT INTO `admin_role_right` VALUES (122, 2, 5, NULL, 'test', '2016-08-16 16:02:57', 'test', '2016-08-16 16:02:57');
INSERT INTO `admin_role_right` VALUES (123, 2, 6, NULL, 'test', '2016-08-16 16:02:57', 'test', '2016-08-16 16:02:57');
INSERT INTO `admin_role_right` VALUES (124, 2, 7, NULL, 'test', '2016-08-16 16:02:57', 'test', '2016-08-16 16:02:57');
INSERT INTO `admin_role_right` VALUES (125, 2, 8, NULL, 'test', '2016-08-16 16:02:57', 'test', '2016-08-16 16:02:57');
INSERT INTO `admin_role_right` VALUES (126, 1, 13, NULL, 'admin', '2018-10-01 11:30:02', 'admin', '2018-10-01 11:30:02');
INSERT INTO `admin_role_right` VALUES (127, 1, 14, NULL, 'admin', '2018-10-01 11:30:02', 'admin', '2018-10-01 11:30:02');
INSERT INTO `admin_role_right` VALUES (128, 1, 15, NULL, 'admin', '2018-10-01 11:30:02', 'admin', '2018-10-01 11:30:02');
INSERT INTO `admin_role_right` VALUES (129, 1, 16, NULL, 'admin', '2018-10-01 11:30:02', 'admin', '2018-10-01 11:30:02');
INSERT INTO `admin_role_right` VALUES (130, 1, 17, NULL, 'admin', '2018-10-01 11:30:02', 'admin', '2018-10-01 11:30:02');
INSERT INTO `admin_role_right` VALUES (131, 1, 18, NULL, 'admin', '2018-10-01 11:30:02', 'admin', '2018-10-01 11:30:02');
INSERT INTO `admin_role_right` VALUES (132, 1, 19, NULL, 'admin', '2018-10-01 11:30:02', 'admin', '2018-10-01 11:30:02');
INSERT INTO `admin_role_right` VALUES (133, 1, 20, NULL, 'admin', '2018-10-01 11:30:02', 'admin', '2018-10-01 11:30:02');
INSERT INTO `admin_role_right` VALUES (134, 1, 21, NULL, 'admin', '2018-10-01 11:30:02', 'admin', '2018-10-01 11:30:02');
INSERT INTO `admin_role_right` VALUES (135, 1, 4, NULL, 'admin', '2018-10-01 11:30:02', 'admin', '2018-10-01 11:30:02');
INSERT INTO `admin_role_right` VALUES (136, 1, 5, NULL, 'admin', '2018-10-01 11:30:02', 'admin', '2018-10-01 11:30:02');
INSERT INTO `admin_role_right` VALUES (137, 1, 6, NULL, 'admin', '2018-10-01 11:30:02', 'admin', '2018-10-01 11:30:02');
INSERT INTO `admin_role_right` VALUES (138, 1, 7, NULL, 'admin', '2018-10-01 11:30:02', 'admin', '2018-10-01 11:30:02');
INSERT INTO `admin_role_right` VALUES (139, 1, 8, NULL, 'admin', '2018-10-01 11:30:02', 'admin', '2018-10-01 11:30:02');
INSERT INTO `admin_role_right` VALUES (140, 1, 22, NULL, 'admin', '2018-10-01 11:30:02', 'admin', '2018-10-01 11:30:02');
COMMIT;

-- ----------------------------
-- Table structure for admin_user
-- ----------------------------
DROP TABLE IF EXISTS `admin_user`;
CREATE TABLE `admin_user` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uname` varchar(100) NOT NULL COMMENT '用户名',
  `password` varchar(200) NOT NULL COMMENT '密码',
  `auth_key` varchar(50) DEFAULT NULL COMMENT '自动登录key',
  `last_ip` varchar(50) DEFAULT NULL COMMENT '最近一次登录ip',
  `is_online` char(1) DEFAULT 'n' COMMENT '是否在线',
  `domain_account` varchar(100) DEFAULT NULL COMMENT '域账号',
  `status` smallint(6) NOT NULL DEFAULT '10' COMMENT '状态',
  `create_user` varchar(100) NOT NULL COMMENT '创建人',
  `create_date` datetime NOT NULL COMMENT '创建时间',
  `update_user` varchar(101) NOT NULL COMMENT '更新人',
  `update_date` datetime NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=159 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of admin_user
-- ----------------------------
BEGIN;
INSERT INTO `admin_user` VALUES (156, 'admin', '$2y$13$9O6bKJieocg//oSax9fZOOuljAKarBXknqD8.RyYg60FfNjS7SoqK', NULL, 'Unknown', 'n', NULL, 10, 'admin', '2014-07-07 00:05:47', 'admin', '2014-09-03 12:19:12');
INSERT INTO `admin_user` VALUES (158, 'test', '$2y$13$9O6bKJieocg//oSax9fZOOuljAKarBXknqD8.RyYg60FfNjS7SoqK', NULL, '', 'n', NULL, 10, 'admin', '2014-09-03 12:19:52', 'admin', '2014-11-21 19:19:22');
COMMIT;

-- ----------------------------
-- Table structure for admin_user_role
-- ----------------------------
DROP TABLE IF EXISTS `admin_user_role`;
CREATE TABLE `admin_user_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `user_id` bigint(20) unsigned NOT NULL COMMENT '用户id',
  `role_id` int(11) NOT NULL COMMENT '角色',
  `create_user` varchar(50) DEFAULT NULL COMMENT '创建人',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `update_user` varchar(50) DEFAULT NULL COMMENT '修改人',
  `update_date` datetime DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`),
  KEY `index_user_id` (`user_id`),
  KEY `index_role_id` (`role_id`),
  CONSTRAINT `admin_user_role_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `admin_user` (`id`) ON DELETE CASCADE,
  CONSTRAINT `admin_user_role_ibfk_2` FOREIGN KEY (`role_id`) REFERENCES `admin_role` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of admin_user_role
-- ----------------------------
BEGIN;
INSERT INTO `admin_user_role` VALUES (1, 156, 1, 'admin', '2016-08-12 17:03:13', 'admin', '2016-08-12 17:03:13');
INSERT INTO `admin_user_role` VALUES (2, 158, 2, 'test', '2016-08-13 16:34:20', 'test', '2016-08-13 16:34:20');
COMMIT;

-- ----------------------------
-- Table structure for images
-- ----------------------------
DROP TABLE IF EXISTS `images`;
CREATE TABLE `images` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) DEFAULT NULL COMMENT '用户id',
  `image` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '图片',
  `brife` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '简介',
  `link` text COLLATE utf8mb4_bin COMMENT '链接',
  `updated_at` int(11) DEFAULT NULL COMMENT '修改时间',
  `created_at` int(11) DEFAULT NULL COMMENT '上传时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Records of images
-- ----------------------------
BEGIN;
INSERT INTO `images` VALUES (1, NULL, 'banner/5bb20b025deee.png', '112', '', 1538394882, NULL);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
